﻿CREATE TABLE [dbo].[Employee_WageJx] (
    [Id]            INT             IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL,
    [Sales]         NVARCHAR (50)   NULL,
    [EName]         NVARCHAR (50)   NULL,
    [TichengPrice]  NUMERIC (18, 2) NULL,
    [MTichengPrice] NUMERIC (18, 2) CONSTRAINT [DF_Employee_WageJx_MTichengPrice] DEFAULT ((0)) NULL,
    [JixiaoPrice]   NUMERIC (18, 2) NULL,
    [JiangjinPrice] NUMERIC (18, 2) NULL,
    [FafangDate]    DATETIME        NULL,
    [CompanyId]     INT             NULL,
    [Description]   NVARCHAR (1000) NULL,
    CONSTRAINT [PK_Employee_JJ] PRIMARY KEY CLUSTERED ([Id] ASC)
);

